package com.aaa.dao;
import org.apache.ibatis.annotations.Select;
import java.util.List;
import java.util.Map;




public interface T_ZfDao {
    @Select("<script> SELECT r.`name`,r.appscore,r.SHtime,s.average1,e.exam_name,r.inscore,r.cpscore,r.kscore,(ifnull(r.inscore+r.appscore-r.cpscore+r.kscore,0)+s.average1)  aa FROM exam e,exam_scorce s,regist r WHERE e.id=s.exam_id AND e.information_id=r.id <if test=\"name!=null and name!=''\"> and r.name like concat('%',#{name},'%') </if>  limit #{start},#{pageSize} </script>")
    List<Map> selectAll(Map map);
    @Select("<script>  SELECT COUNT(id) from  exam_scorce WHERE 1=1 <if test=\"name!=null and name!=''\"> and a.name like concat('%',#{name},'%') </if> </script>")
    Integer  getCount(Map map);
}
